<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCollectionLogin extends Migration{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up(){
        Schema::create('collection_login', function(Blueprint $table){
            $table->engine = 'MyISAM';
            $table->comment = '采集登录表';
            $table->increments('id')->unsigned()->comment('自动增长主键');
            $table->string('url', 255)->default('')->comment('采集网站地址');
            $table->string('username', 60)->default('')->comment('用户名');
            $table->text('password')->default('')->comment('密码');
            $table->string('source', 100)->default('')->comment('网站来源');
            $table->tinyInteger('type')->unsigned()->default(0)->comment('采集类型(1简历采集，2企业采集)');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down(){
        Schema::drop('collection_login');
    }
}
